if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Admin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Admin]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Message]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Message]
GO

CREATE TABLE [dbo].[Admin] (
[Password] nvarchar(50)
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Message] (
[AdminFeedback] ntext,
[AdminFeedbackTime] datetime,
[Content] ntext,
[Email] nvarchar(255),
[ID] int IDENTITY (1, 1)  NOT NULL,
[IsPrivate] bit,
[Nick] nvarchar(50),
[PostTime] datetime
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Message] WITH NOCHECK ADD
CONSTRAINT [PK_Message] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
GO

CREATE INDEX [ID] ON [dbo].[Message]([ID]) ON [PRIMARY]
GO

